| FaTsmFahAlert |
| Logical Entity Name | FaTsmFahAlert |
| Default Table Name | FaTsmFahAlert |
| Physical Only | NO |
| Definition | |
| Note |
| FaTsmFahAlert Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
FaTsmFahAlertID |
char(10) | NO | ||
| TsmType | char(10) | NO | ||
| StudentSsn | char(10) | NO | ||
| FirstName | char(10) | NO | ||
| LastName | char(10) | NO | ||
| DateOfBirth | char(10) | NO | ||
| SchoolCode | char(10) | YES | ||
| BatchId | char(10) | NO | ||
| FahTsmAlertHeaderRecord | char(10) | YES | ||
| AggrPerkinsFlagsRecord | char(10) | YES | ||
| NameHistoryRecord | char(10) | YES | ||
| OverpaymentRecord | char(10) | YES | ||
| GrantPaymentRecord | char(10) | YES | ||
| LoanDetailRecord | char(10) | YES | ||
| FahTsmAlertTrailerRecord | char(10) | YES | ||
| DateAdded | char(10) | NO | ||
| DateLstMod | char(10) | NO | ||
| ts | char(10) | NO | ||
| UserId | char(10) | NO | ||
| FaTsmMainId | char(10) | YES |
| FaTsmFahAlert Primary and Unique Keys |
| Key Name | Key Type | Keys |
| PK_FaTsmFahAlert_FaTsmFahAlertID | PrimaryKey | FaTsmFahAlertID |
| FaTsmFahAlert Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| FaTsmFahAlert Check Constraints |
| Check Constraint Name | CheckConstraint |